Tabela Chemotherapy

Definicja tabeli Chemotherapy

Name

Chemotherapy

Code

Chemotherapy

Comment

 


Lista kolumn tabeli Chemotherapy

Name

Code

ChemotherapyID

ChemotherapyID

TreatmentSchemaID

TreatmentSchemaID

ParamTypeID

ParamTypeID

SubstanceGroup

SubstanceGroup

TreatmentDayNo

TreatmentDayNo

BodyArea

BodyArea

BodyWeight

BodyWeight

TreatmentDaysCount

TreatmentDaysCount

isGivenToPatient

isGivenToPatient

UnitsCount

UnitsCount

EAN

EAN


Kolumna ChemotherapyID tabeli Chemotherapy

Definicja kolumny ChemotherapyID tabeli Chemotherapy

Name

ChemotherapyID

Code

ChemotherapyID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TreatmentSchemaID tabeli Chemotherapy

Definicja kolumny TreatmentSchemaID tabeli Chemotherapy

Name

TreatmentSchemaID

Code

TreatmentSchemaID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ParamTypeID tabeli Chemotherapy

Definicja kolumny ParamTypeID tabeli Chemotherapy

Name

ParamTypeID

Code

ParamTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SubstanceGroup tabeli Chemotherapy

Definicja kolumny SubstanceGroup tabeli Chemotherapy

Name

SubstanceGroup

Code

SubstanceGroup

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna TreatmentDayNo tabeli Chemotherapy

Definicja kolumny TreatmentDayNo tabeli Chemotherapy

Name

TreatmentDayNo

Code

TreatmentDayNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BodyArea tabeli Chemotherapy

Definicja kolumny BodyArea tabeli Chemotherapy

Name

BodyArea

Code

BodyArea

Data Type

NUMBER(11,4)

Mandatory

No

Comment

 


Kolumna BodyWeight tabeli Chemotherapy

Definicja kolumny BodyWeight tabeli Chemotherapy

Name

BodyWeight

Code

BodyWeight

Data Type

NUMBER(11,4)

Mandatory

No

Comment

 


Kolumna TreatmentDaysCount tabeli Chemotherapy

Definicja kolumny TreatmentDaysCount tabeli Chemotherapy

Name

TreatmentDaysCount

Code

TreatmentDaysCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna isGivenToPatient tabeli Chemotherapy

Definicja kolumny isGivenToPatient tabeli Chemotherapy

Name

isGivenToPatient

Code

isGivenToPatient

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli Chemotherapy

Definicja kolumny UnitsCount tabeli Chemotherapy

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(16,4)

Mandatory

No

Comment

 


Kolumna EAN tabeli Chemotherapy

Definicja kolumny EAN tabeli Chemotherapy

Name

EAN

Code

EAN

Data Type

VARCHAR2(14)

Mandatory

No

Comment

Europejski kod towarowy (EAN) produktu lekowego lub inny kod odpowiadajcy kodowi EAN


Lista kluczy tabeli Chemotherapy

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Chemotherapy

Definicja klucza Identifier_1 tabeli Chemotherapy

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment